package com.ruoyi.reportsnhnt.mapper;

import com.ruoyi.report_sj.domain.ReportSjkyqdBaDetail;
import com.ruoyi.reportsnhnt.domain.ReportSnhntPhbsjBaDetail;
import com.ruoyi.reportsnhnt.domain.ReportSnhntPhbsjsybgBaDetail;
import com.ruoyi.reportsnhnt.domain.vo.ReportSnhntPhbsjsybgBaDetailVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 普通混凝土配合比设计试验检测报告子Mapper接口
 *
 * @author zxs
 * @date 2024-08-28
 */
public interface ReportSnhntPhbsjsybgBaDetailMapper extends BaseMapperPlus<ReportSnhntPhbsjsybgBaDetailMapper, ReportSnhntPhbsjsybgBaDetail, ReportSnhntPhbsjsybgBaDetailVo> {

    @Select("select phb.* from report_snhnt_phbsj_ba_detail phb,syrw_ref_report_excel ref,syrw_bi_excel_type bi where ref.excel_type_id = bi.excel_type_id and phb.excel_id = ref.excel_id " +
        " and ref.report_id = (select report_id from syrw_ref_report_excel where excel_id = #{excelId}) and bi.label ='snhntphbsjsyjcjl' ")
    List<ReportSnhntPhbsjBaDetail> selectListByBgExcelId(Long excelId);
}
